# coding: utf-8
from . import db, BaseModel


class PsyConsultant(db.Model):
    __tablename__ = 'psy_consultant'

    auto_id = db.Column(db.BigInteger, primary_key=True, info='自增id')
    psy_id = db.Column(db.BigInteger, index=True, info='咨询师id')
    psy_name = db.Column(db.String(20, 'utf8mb4_0900_ai_ci'), server_default=db.FetchedValue(), info='姓名')
    psy_sex = db.Column(db.String(5, 'utf8mb4_0900_ai_ci'), server_default=db.FetchedValue(), info='性别')
    psy_password = db.Column(db.String(50, 'utf8mb4_0900_ai_ci'), server_default=db.FetchedValue(), info='密码')
    psy_phone = db.Column(db.String(50, 'utf8mb4_0900_ai_ci'), server_default=db.FetchedValue(), info='联系方式')
    psy_pic = db.Column(db.String(255, 'utf8mb4_0900_ai_ci'), server_default=db.FetchedValue(), info='头像url')
    psy_servetime = db.Column(db.Integer, server_default=db.FetchedValue(), info='服务时间')
    psy_helpnum = db.Column(db.Integer, server_default=db.FetchedValue(), info='帮助人数')
    is_use = db.Column(db.Integer, server_default=db.FetchedValue(), info='账号是否启用 1-是 0-否')
    is_delete = db.Column(db.Integer, server_default=db.FetchedValue(), info='是否已删除 1-是 0-否')
    create_time = db.Column(db.DateTime, server_default=db.FetchedValue(), info='创建时间')
    update_time = db.Column(db.DateTime, server_default=db.FetchedValue(), info='更新时间')
